Balance Sheet Account Settings

The Balance Sheet Account Settings page configures settings for balance sheet accounts associated with the Simple Interest, Non-Interest, and Cash Flow calculation methods.

  • To sort the table display by interest type, click the up or down arrow at the top of the Interest type column.
  • To filter the display based on interest types, click the filter icon and use the Filter Wizard dialog to select filters.
  • To search for specific accounts, enter text in the Search for accounts or descriptions field.

To edit the settings for balance sheet accounts:

  1. From the Command Center home page, click Financial Planning.
  2. Open the budget, scenario, or forecast for which to edit the driver.
  3. Select the Drivers & Assumptions tab.

  4. Click the Balance Sheet Account Settings link.

  5. Select the tab for one of the following calculation methods associated with balance sheet accounts: 

    • Simple & Non-Interest for accounts assigned to either the Simple Interest method or the Non-Interest method
    • Cash Flow for accounts assigned to the Cash Flow method

    TIP: For more information about these calculation methods, see Balance Sheet tab calculation method library.

  6. Select one or more accounts by selecting the check box in the far left column, then click Edit.

    NOTE: When more than one account is selected, the Edit button displays the number of accounts currently selected (for example, Edit 2 when two accounts are selected).

  7. In the Edit dialog, complete the following settings:

    Field Description
    Users can spread over interest index

    Enter a spread percentage over the interest index as an integer value (for example, 2.5 for a 2.5% interest rate).

    NOTE: In the Cash Flow calculation method, the interest rate for a new volume (new account) is calculated as the interest index rate plus the spread over the interest index.
    Balance forecast method

    Select a balance forecast method from the drop-down list.

    TIP: For more information, see Balance forecast methods.

    Allow users to change balance forecast method
    • Select the check box to allow users of the FI Suite to change the selection of balance forecast method from the budget plan file.
    • Deselect (uncheck) the check box to disallow users from changing the selection. When the box is unchecked, users will be limited to the method selected on the Balance Sheet Account Settings page.
    Allow users to change average balance
    • Select the check box to allow users of the FI Suite to change the calculation type for average balance from the budget plan file.
    • Deselect (uncheck) the check box to disallow users from changing the selection. When the box is unchecked, users will be limited to the calculation type selected on the Balance Sheet Account Settings page.

    NOTE: This field applies only to the Simple Interest and Non-Interest calculation methods.
    Average balance calc type

    When Allow users to change average balance is selected, select either of the following from the drop-down list: 2 Point Average or Ending Balance.

    NOTE: This field applies only to the Simple Interest and Non-Interest calculation methods.

    Allow account interest spread adjustment
    • Select the check box to allow users of the FI Suite to change the spread over the interest index from the budget plan file. This selection enables users to control the interest rate for a new volume (new account) with an adjustment to the spread.

    • Deselect (uncheck) the check box to disallow users from changing the spread. When the box is unchecked, users will be limited to the spread entered on the Balance Sheet Account Settings page.

    NOTE: This field applies only to the Cash Flow calculation method.

    Allow user to adjust new volume rate
    • Select the check box to allow users of the FI Suite to change the interest rate assigned to a new volume (new account) from the budget plan file.
    • Deselect (uncheck) the check box to disallow users from changing the rate.

    NOTE: This field applies only to the Cash Flow calculation method.

    Minimum plan years for Cash Flow

    Enter the number of plan years the Input New Volume Balance method will be active when either the Input new vol / Year end balance or Input new vol / Annual Growth Rate are selected as the balance forecast method.

    If, for example, this column is set to 1, the forecaster must enter new volumes through the first planning year for that account. For the remaining plan years, the user will forecast balances by entering either annual growth rates or year-end balances.

    NOTE: This field applies only to the Cash Flow calculation method.

    To save all changes, click Edit.

    To close the dialog without saving changes, click Cancel.

  8. To save all changes, click Save.

Balance forecast methods

This column of the table on the Balance Sheet Account Settings page lists the initial method used to project plan balances for the balance sheet planning accounts. The method displayed in the column is selected from a drop-down list in the Edit dialog that opens when you click the Edit button while one or more accounts are selected.

Initially, the column is populated with Input new volume for accounts using the Cash Flow calculation method and with Apply growth rate for accounts using the Simple Interest and Non-Interest calculation methods.

  • All plan accounts can be assigned to the following balance forecast methods:
    • Apply growth rate
    • Input monthly balance
    • Input year end balance
  • Plan accounts using the Cash Flow calculation method can also be assigned to:
    • Input new volume
  • Plan accounts that have seed values and that use the Cash Flow calculation method can also be assigned to:
    • Input new volume / Year end balance
    • Input new volume / Annual Growth Rate

TIP: For more information about these calculation methods, see Balance Sheet tab calculation method library.